Melissa Yamada
Melissa Yamada
-
Re: Index IF formula for data in Row bases on Column data
Hello @Marielitos If you're going through the path of using formulas, you'll need to create the formula on each column on your destination sheet. Also, I think you'd want to use INDEX/COLLECT functio…1 · -
Re: Did changing the column title permanently break the formula from sheet to sheet?
Hello @PhyllisB Since you're using a multi-select dropdown on your source sheet, your current formula doesn't count rows with multiple values. In this case, you'll need to incorporate the HAS functio…1 · -
Re: Average of Color Symbols (RYG) on same row
Hello @SherryFox Try this: =IF(COUNTIF(Cost1:Performance1, "Red") = COUNT(Cost1:Performance1), "Red", IF(COUNTIF(Cost1:Performance1, "Green") = COUNT(Cost1:Performance1)…1 · -
Re: Override Column Formula
Hello @wispsofsmoke You can follow @Paul Newcome's formula. You just need to add the additional IF statement at the first part of your formula to check whether the Date Override column is blank or no…1 · -
Re: Override Column Formula
Hello @wispsofsmoke A work around is to create a helper column (Date Override column) then on your main column with the column formula you can add an IF statement that if there is date in the "D…1 ·
